package com.pgybook.db.entity.mapper;

import org.springframework.stereotype.Repository;
import com.pgybook.db.entity.domain.StaffOperationDailyAnalysis;
import com.pgybook.db.entity.domain.StaffOperationDailyAnalysisEx;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;

@Repository
public interface StaffOperationDailyAnalysisMapper {
    int countByExample(StaffOperationDailyAnalysisEx example);

    int deleteByExample(StaffOperationDailyAnalysisEx example);

    @Insert({
            "insert into staffoperationdailyanalysis (LIBID, BZDAY, ",
            "STAFFID, STAFFNAME, ",
            "ORDERNUM, BOOKNUMINORDER, ",
            "UPLOADBOOKNUM)",
            "values (#{libid,jdbcType=INTEGER}, #{bzday,jdbcType=DATE}, ",
            "#{staffid,jdbcType=INTEGER}, #{staffname,jdbcType=VARCHAR}, ",
            "#{ordernum,jdbcType=INTEGER}, #{booknuminorder,jdbcType=INTEGER}, ",
            "#{uploadbooknum,jdbcType=INTEGER})"
    })
    int insert(StaffOperationDailyAnalysis record);

    int insertSelective(StaffOperationDailyAnalysis record);

    List<StaffOperationDailyAnalysis> selectByExample(StaffOperationDailyAnalysisEx example);

    int updateByExampleSelective(@Param("record") StaffOperationDailyAnalysis record, @Param("example") StaffOperationDailyAnalysisEx example);

    int updateByExample(@Param("record") StaffOperationDailyAnalysis record, @Param("example") StaffOperationDailyAnalysisEx example);
}
